SQL Server returning Empty Fields and there should be data

--____HXWGLCRLOMQETQHKBMOV____
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hello All,

I am having a very odd problem. With a database I recently created on =
MSSQL 2K (Win2K Server Machine), I use a Stored Procedure to handle =
getting the fields I need.

If I use MS Access to open the Stored Procedure (in an ADP File) it works =
100%, same goes through Enterprise Manager.

When I use an ASP Page, most of the fields have the data in them, but =
others are simply blank. There aren't any errors returned (and I don't =
have "On Error Resume Next" set) but the fields are simply empty.

Here is how I open the SP:
rs.Open nfad.spWebNewDevelopmentsAdminDetailedInfo " & id, conn

The id portion just passes the specific record ID to the SP and then I =
reference my recordset like this:

Project: ) %>">
Street Number: maxlength=3D"10" value=3D"<%=3Drs("BUS_STREET_NUM")%>">

I have error checking in to make sure it returns a record and most of the =
fields populate with data so I know that data is coming out of the SQL =
Server. For example, in the two lines above, the Project Input box would =
have the project name in the field but the Street Number won't. If I were =
to open the SP in Enterprise Manager or MS Access, it would show that =
there is data in the field and that I am using the proper naming, etc. =
Otherwise, if I wasn't, it would return an error (couldn't find the =
ordinal, etc...)

Sorry for the long winded post, hopefully I have explained enough.

Any help would be great!

Thanks,
Shawn

--____HXWGLCRLOMQETQHKBMOV____
Content-Type: multipart/related; boundary="____AEKAPGWAODDNQRBFSAKD____"


--____AEKAPGWAODDNQRBFSAKD____
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable


>

Re: SQL Server returning Empty Fields and there should be data

See if this helps

http://www.aspfaq.com/show.asp?id=2188

--
--Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com

"Shawn Oatley" wrote in message
news:OB%23xdUdSFHA.1972@TK2MSFTNGP10.phx.gbl...
Hello All,

I am having a very odd problem. With a database I recently created on MSSQL
2K (Win2K Server Machine), I use a Stored Procedure to handle getting the
fields I need.

If I use MS Access to open the Stored Procedure (in an ADP File) it works
100%, same goes through Enterprise Manager.

When I use an ASP Page, most of the fields have the data in them, but others
are simply blank. There aren't any errors returned (and I don't have "On
Error Resume Next" set) but the fields are simply empty.

Here is how I open the SP:
rs.Open nfad.spWebNewDevelopmentsAdminDetailedInfo " & id, conn

The id portion just passes the specific record ID to the SP and then I
reference my recordset like this:

Project: ">
Street Number: value="<%=rs("BUS_STREET_NUM")%>">

I have error checking in to make sure it returns a record and most of the
fields populate with data so I know that data is coming out of the SQL
Server. For example, in the two lines above, the Project Input box would
have the project name in the field but the Street Number won't. If I were
to open the SP in Enterprise Manager or MS Access, it would show that there
is data in the field and that I am using the proper naming, etc. Otherwise,
if I wasn't, it would return an error (couldn't find the ordinal, etc...)

Sorry for the long winded post, hopefully I have explained enough.

Any help would be great!

Thanks,
Shawn



------------------------------------------------------------ --------------------


Hello All,

I am having a very odd problem. With a database I recently created on MSSQL
2K (Win2K Server Machine), I use a Stored Procedure to handle getting the
fields I need.

If I use MS Access to open the Stored Procedure (in an ADP File) it works
100%, same goes through Enterprise Manager.

When I use an ASP Page, most of the fields have the data in them, but others
are simply blank. There aren't any errors returned (and I don't have "On
Error Resume Next" set) but the fields are simply empty.

Here is how I open the SP:
rs.Open nfad.spWebNewDevelopmentsAdminDetailedInfo " & id, conn

The id portion just passes the specific record ID to the SP and then I
reference my recordset like this:

Project: ">
Street Number: value="<%=rs("BUS_STREET_NUM")%>">

I have error checking in to make sure it returns a record and most of the
fields populate with data so I know that data is coming out of the SQL
Server. For example, in the two lines above, the Project Input box would
have the project name in the field but the Street Number won't. If I were
to open the SP in Enterprise Manager or MS Access, it would show that there
is data in the field and that I am using the proper naming, etc. Otherwise,
if I wasn't, it would return an error (couldn't find the ordinal, etc...)

Sorry for the long winded post, hopefully I have explained enough.

Any help would be great!

Thanks,
Shawn

Re: SQL Server returning Empty Fields and there should be data

--____NZLBKUNIBYRTEXKGSCVE____
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi Mark,

Yep, that did the trick!

Thanks,
Shawn

>>> Mark Schupp 4/25/2005 4:39 PM >>>

See if this helps

http://www.aspfaq.com/show.asp?id=3D2188

--=20
--Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com

"Shawn Oatley" wrote in message=20
news:OB%23xdUdSFHA.1972@TK2MSFTNGP10.phx.gbl...
Hello All,

I am having a very odd problem. With a database I recently created on =
MSSQL=20
2K (Win2K Server Machine), I use a Stored Procedure to handle getting =
the=20
fields I need.

If I use MS Access to open the Stored Procedure (in an ADP File) it =
works=20
100%, same goes through Enterprise Manager.

When I use an ASP Page, most of the fields have the data in them, but =
others=20
are simply blank. There aren't any errors returned (and I don't have =
"On=20
Error Resume Next" set) but the fields are simply empty.

Here is how I open the SP:
rs.Open nfad.spWebNewDevelopmentsAdminDetailedInfo " & id, conn

The id portion just passes the specific record ID to the SP and then I=20
reference my recordset like this:

Project: ) %>">
Street Number: maxlength=3D"10"=20
value=3D"<%=3Drs("BUS_STREET_NUM")%>">

I have error checking in to make sure it returns a record and most of =
the=20
fields populate with data so I know that data is coming out of the SQL=20
Server. For example, in the two lines above, the Project Input box =
would=20
have the project name in the field but the Street Number won't. If I =
were=20
to open the SP in Enterprise Manager or MS Access, it would show that =
there=20
is data in the field and that I am using the proper naming, etc. =
Otherwise,=20
if I wasn't, it would return an error (couldn't find the ordinal, etc...)

Sorry for the long winded post, hopefully I have explained enough.

Any help would be great!

Thanks,
Shawn



------------------------------------------------------------ ---------------=
-----


Hello All,

I am having a very odd problem. With a database I recently created on =
MSSQL=20
2K (Win2K Server Machine), I use a Stored Procedure to handle getting =
the=20
fields I need.

If I use MS Access to open the Stored Procedure (in an ADP File) it =
works=20
100%, same goes through Enterprise Manager.

When I use an ASP Page, most of the fields have the data in them, but =
others=20
are simply blank. There aren't any errors returned (and I don't have =
"On=20
Error Resume Next" set) but the fields are simply empty.

Here is how I open the SP:
rs.Open nfad.spWebNewDevelopmentsAdminDetailedInfo " & id, conn

The id portion just passes the specific record ID to the SP and then I=20
reference my recordset like this:

Project: ) %>">
Street Number: maxlength=3D"10"=20
value=3D"<%=3Drs("BUS_STREET_NUM")%>">

I have error checking in to make sure it returns a record and most of =
the=20
fields populate with data so I know that data is coming out of the SQL=20
Server. For example, in the two lines above, the Project Input box =
would=20
have the project name in the field but the Street Number won't. If I =
were=20
to open the SP in Enterprise Manager or MS Access, it would show that =
there=20
is data in the field and that I am using the proper naming, etc. =
Otherwise,=20
if I wasn't, it would return an error (couldn't find the ordinal, etc...)

Sorry for the long winded post, hopefully I have explained enough.

Any help would be great!

Thanks,
Shawn

--____NZLBKUNIBYRTEXKGSCVE____
Content-Type: multipart/related; boundary="____FWWRIVMYIKESAEPNSDUF____"


--____FWWRIVMYIKESAEPNSDUF____
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable


>